Pandas Profiling Report

Dataset statistics

Number of variables	20
Number of observations	627868
Missing cells	1098738
Missing cells (%)	8.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	95.8 MiB
Average record size in memory	160.0 B

Variable types

Categorical	10
Numeric	7
Unsupported	2
Boolean	1

Warnings

`State` has constant value "Cross River"	Constant
`Regimen` has a high cardinality: 88 distinct values	High cardinality
`PHARMACY_ID` is highly correlated with `PATIENT_ID` and 1 other fields	High correlation
`PATIENT_ID` is highly correlated with `PHARMACY_ID` and 1 other fields	High correlation
`FACILITY_ID` is highly correlated with `PHARMACY_ID` and 1 other fields	High correlation
`AFTERNOON` is highly correlated with `EVENING`	High correlation
`EVENING` is highly correlated with `AFTERNOON`	High correlation
`PHARMACY_ID` is highly correlated with `PATIENT_ID`	High correlation
`PATIENT_ID` is highly correlated with `PHARMACY_ID` and 1 other fields	High correlation
`FACILITY_ID` is highly correlated with `PATIENT_ID`	High correlation
`PATIENT_ID` is highly correlated with `FACILITY_ID`	High correlation
`FACILITY_ID` is highly correlated with `PATIENT_ID`	High correlation
`DMOC_TYPE` is highly correlated with `PHARMACY_ID` and 1 other fields	High correlation
`FACILITY_ID` is highly correlated with `PHARMACY_ID` and 3 other fields	High correlation
`ADHERENCE` is highly correlated with `Regimen`	High correlation
`PHARMACY_ID` is highly correlated with `DMOC_TYPE` and 4 other fields	High correlation
`Regimen Line` is highly correlated with `Regimen`	High correlation
`L.G.A` is highly correlated with `FACILITY_ID` and 3 other fields	High correlation
`Regimen` is highly correlated with `ADHERENCE` and 2 other fields	High correlation
`EVENING` is highly correlated with `AFTERNOON` and 1 other fields	High correlation
`AFTERNOON` is highly correlated with `EVENING` and 1 other fields	High correlation
`PATIENT_ID` is highly correlated with `FACILITY_ID` and 3 other fields	High correlation
`Facility Name` is highly correlated with `DMOC_TYPE` and 4 other fields	High correlation
`MORNING` is highly correlated with `EVENING` and 1 other fields	High correlation
`ADR_IDS` is highly correlated with `Regimen`	High correlation
`ADR_SCREENED` has 10322 (1.6%) missing values	Missing
`ADR_IDS` has 627858 (> 99.9%) missing values	Missing
`DMOC_TYPE` has 460552 (73.4%) missing values	Missing
`DURATION` is highly skewed (γ1 = 606.5115674)	Skewed
`MORNING` is highly skewed (γ1 = 148.0439747)	Skewed
`EVENING` is highly skewed (γ1 = 324.8214677)	Skewed
`BODY_WEIGHT` is highly skewed (γ1 = 138.7964098)	Skewed
`PHARMACY_ID` has unique values	Unique
`DATE_VISIT` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`NEXT_APPOINTMENT` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`MORNING` has 225607 (35.9%) zeros	Zeros
`EVENING` has 199008 (31.7%) zeros	Zeros
`BODY_WEIGHT` has 625049 (99.6%) zeros	Zeros

Reproduction

Analysis started	2021-06-15 08:56:22.296203
Analysis finished	2021-06-15 08:57:40.913466
Duration	1 minute and 18.62 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

State
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.8 MiB

Cross River	627868

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	6906548
Distinct characters	9
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Cross River
2nd row	Cross River
3rd row	Cross River
4th row	Cross River
5th row	Cross River

Common Values

Value	Count	Frequency (%)
Cross River	627868	100.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
cross	627868	50.0%
river	627868	50.0%

Most occurring characters

Value	Count	Frequency (%)
r	1255736	18.2%
s	1255736	18.2%
C	627868	9.1%
o	627868	9.1%
	627868	9.1%
R	627868	9.1%
i	627868	9.1%
v	627868	9.1%
e	627868	9.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5022944	72.7%
Uppercase Letter	1255736	18.2%
Space Separator	627868	9.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	1255736	25.0%
s	1255736	25.0%
o	627868	12.5%
i	627868	12.5%
v	627868	12.5%
e	627868	12.5%

Uppercase Letter

Value	Count	Frequency (%)
C	627868	50.0%
R	627868	50.0%

Space Separator

Value	Count	Frequency (%)
	627868	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6278680	90.9%
Common	627868	9.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	1255736	20.0%
s	1255736	20.0%
C	627868	10.0%
o	627868	10.0%
R	627868	10.0%
i	627868	10.0%
v	627868	10.0%
e	627868	10.0%

Common

Value	Count	Frequency (%)
	627868	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6906548	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	1255736	18.2%
s	1255736	18.2%
C	627868	9.1%
o	627868	9.1%
	627868	9.1%
R	627868	9.1%
i	627868	9.1%
v	627868	9.1%
e	627868	9.1%

L.G.A
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.8 MiB

Ogoja	367647
Obudu	143668
Obanliku	63739
Yala	52814

Length

Max length	8
Median length	5
Mean length	5.220433276
Min length	4

Characters and Unicode

Total characters	3277743
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Obudu
2nd row	Obudu
3rd row	Obudu
4th row	Obudu
5th row	Obudu

Common Values

Value	Count	Frequency (%)
Ogoja	367647	58.6%
Obudu	143668	22.9%
Obanliku	63739	10.2%
Yala	52814	8.4%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
ogoja	367647	58.6%
obudu	143668	22.9%
obanliku	63739	10.2%
yala	52814	8.4%

Most occurring characters

Value	Count	Frequency (%)
O	575054	17.5%
a	537014	16.4%
g	367647	11.2%
o	367647	11.2%
j	367647	11.2%
u	351075	10.7%
b	207407	6.3%
d	143668	4.4%
l	116553	3.6%
n	63739	1.9%
Other values (3)	180292	5.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2649875	80.8%
Uppercase Letter	627868	19.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	537014	20.3%
g	367647	13.9%
o	367647	13.9%
j	367647	13.9%
u	351075	13.2%
b	207407	7.8%
d	143668	5.4%
l	116553	4.4%
n	63739	2.4%
i	63739	2.4%

Uppercase Letter

Value	Count	Frequency (%)
O	575054	91.6%
Y	52814	8.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3277743	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	575054	17.5%
a	537014	16.4%
g	367647	11.2%
o	367647	11.2%
j	367647	11.2%
u	351075	10.7%
b	207407	6.3%
d	143668	4.4%
l	116553	3.6%
n	63739	1.9%
Other values (3)	180292	5.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3277743	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
O	575054	17.5%
a	537014	16.4%
g	367647	11.2%
o	367647	11.2%
j	367647	11.2%
u	351075	10.7%
b	207407	6.3%
d	143668	4.4%
l	116553	3.6%
n	63739	1.9%
Other values (3)	180292	5.5%

Facility Name
Categorical

HIGH CORRELATION

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.8 MiB

Ogoja General Hospital	193461
Ogoja Catholic Maternity Hospital	158799
Sacred Heart Catholic Hospital	118501
Obanliku General Hospital	63739
Yala Lutheran Hospital	30441
Other values (6)	62927

Length

Max length	35
Median length	25
Mean length	26.72374607
Min length	12

Characters and Unicode

Total characters	16778985
Distinct characters	34
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Obudu Clinic
2nd row	Obudu Clinic
3rd row	Obudu Clinic
4th row	Obudu Clinic
5th row	Obudu Clinic

Common Values

Value	Count	Frequency (%)
Ogoja General Hospital	193461	30.8%
Ogoja Catholic Maternity Hospital	158799	25.3%
Sacred Heart Catholic Hospital	118501	18.9%
Obanliku General Hospital	63739	10.2%
Yala Lutheran Hospital	30441	4.8%
Obudu Clinic	17916	2.9%
Ogoja Santa Maria Clinic	15387	2.5%
Oba Comprehensive Health Centre	9632	1.5%
Okpoma General Hospital	9256	1.5%
Obudu Urban1 Primary Health Centre	7251	1.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
hospital	574197	26.3%
ogoja	367647	16.8%
catholic	277300	12.7%
general	266456	12.2%
maternity	158799	7.3%
sacred	118501	5.4%
heart	118501	5.4%
obanliku	63739	2.9%
clinic	33303	1.5%
yala	30441	1.4%
Other values (12)	177110	8.1%

Most occurring characters

Value	Count	Frequency (%)
a	2155254	12.8%
	1558126	9.3%
t	1374160	8.2%
l	1265804	7.5%
o	1241517	7.4%
i	1179881	7.0%
e	1063094	6.3%
r	763323	4.5%
H	713066	4.2%
n	612346	3.6%
Other values (24)	4852414	28.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	13027614	77.6%
Uppercase Letter	2185994	13.0%
Space Separator	1558126	9.3%
Decimal Number	7251	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	2155254	16.5%
t	1374160	10.5%
l	1265804	9.7%
o	1241517	9.5%
i	1179881	9.1%
e	1063094	8.2%
r	763323	5.9%
n	612346	4.7%
p	596570	4.6%
s	587314	4.5%
Other values (11)	2188351	16.8%

Uppercase Letter

Value	Count	Frequency (%)
H	713066	32.6%
O	475441	21.7%
C	344088	15.7%
G	266456	12.2%
M	174186	8.0%
S	133888	6.1%
Y	30441	1.4%
L	30441	1.4%
U	7251	0.3%
P	7251	0.3%

Space Separator

Value	Count	Frequency (%)
	1558126	100.0%

Decimal Number

Value	Count	Frequency (%)
1	7251	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	15213608	90.7%
Common	1565377	9.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	2155254	14.2%
t	1374160	9.0%
l	1265804	8.3%
o	1241517	8.2%
i	1179881	7.8%
e	1063094	7.0%
r	763323	5.0%
H	713066	4.7%
n	612346	4.0%
p	596570	3.9%
Other values (22)	4248593	27.9%

Common

Value	Count	Frequency (%)
	1558126	99.5%
1	7251	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16778985	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	2155254	12.8%
	1558126	9.3%
t	1374160	8.2%
l	1265804	7.5%
o	1241517	7.4%
i	1179881	7.0%
e	1063094	6.3%
r	763323	4.5%
H	713066	4.2%
n	612346	3.6%
Other values (24)	4852414	28.9%

Regimen Line
Categorical

HIGH CORRELATION

Distinct	13
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.8 MiB

ART First Line Adult	469457
Cotrimoxazole (CTX) Prophylaxis	98270
ART First Line Children	21258
Isoniazid Preventive Therapy (IPT)	19569
ART Second Line Adult	18451
Other values (8)	863

Length

Max length	46
Median length	20
Mean length	22.29019635
Min length	4

Characters and Unicode

Total characters	13995301
Distinct characters	39
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	ART First Line Adult
2nd row	ART First Line Adult
3rd row	ART First Line Adult
4th row	Cotrimoxazole (CTX) Prophylaxis
5th row	ART First Line Adult

Common Values

Value	Count	Frequency (%)
ART First Line Adult	469457	74.8%
Cotrimoxazole (CTX) Prophylaxis	98270	15.7%
ART First Line Children	21258	3.4%
Isoniazid Preventive Therapy (IPT)	19569	3.1%
ART Second Line Adult	18451	2.9%
ART Second Line Children	612	0.1%
OI Treatment	209	< 0.1%
Other Medicines	22	< 0.1%
TB Treatment Adult	9	< 0.1%
Other anti-infectives (including STI Medicine)	5	< 0.1%
Other values (3)	6	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
art	509778	21.1%
line	509778	21.1%
first	490715	20.3%
adult	487917	20.2%
prophylaxis	98273	4.1%
cotrimoxazole	98270	4.1%
ctx	98270	4.1%
children	21871	0.9%
therapy	19569	0.8%
preventive	19569	0.8%
Other values (16)	58719	2.4%

Most occurring characters

Value	Count	Frequency (%)
	1784861	12.8%
i	1277693	9.1%
t	1096949	7.8%
A	997695	7.1%
r	748518	5.3%
e	727790	5.2%
l	706336	5.0%
T	647420	4.6%
s	608590	4.3%
n	590116	4.2%
Other values (29)	4809333	34.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8306549	59.4%
Uppercase Letter	3668192	26.2%
Space Separator	1784861	12.8%
Open Punctuation	117847	0.8%
Close Punctuation	117847	0.8%
Dash Punctuation	5	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	1277693	15.4%
t	1096949	13.2%
r	748518	9.0%
e	727790	8.8%
l	706336	8.5%
s	608590	7.3%
n	590116	7.1%
d	548452	6.6%
u	487925	5.9%
o	431721	5.2%
Other values (11)	1082459	13.0%

Uppercase Letter

Value	Count	Frequency (%)
A	997695	27.2%
T	647420	17.6%
R	509778	13.9%
L	509778	13.9%
F	490715	13.4%
C	218411	6.0%
P	137424	3.7%
X	98270	2.7%
I	39352	1.1%
S	19068	0.5%
Other values (4)	281	< 0.1%

Space Separator

Value	Count	Frequency (%)
	1784861	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	117847	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	117847	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	5	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11974741	85.6%
Common	2020560	14.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	1277693	10.7%
t	1096949	9.2%
A	997695	8.3%
r	748518	6.3%
e	727790	6.1%
l	706336	5.9%
T	647420	5.4%
s	608590	5.1%
n	590116	4.9%
d	548452	4.6%
Other values (25)	4025182	33.6%

Common

Value	Count	Frequency (%)
	1784861	88.3%
(	117847	5.8%
)	117847	5.8%
-	5	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	13995301	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1784861	12.8%
i	1277693	9.1%
t	1096949	7.8%
A	997695	7.1%
r	748518	5.3%
e	727790	5.2%
l	706336	5.0%
T	647420	4.6%
s	608590	4.3%
n	590116	4.2%
Other values (29)	4809333	34.4%

Regimen
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct	88
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.8 MiB

TDF(300mg)+3TC(300mg)+DTG(50mg)	206641
TDF(300mg)+3TC(300mg)+EFV(600mg)	150496
AZT(300mg)+3TC(150mg)+NVP(200mg)	101110
Cotrimoxazole 960mg	93214
Isoniazid 300mg	19095
Other values (83)	57312

Length

Max length	62
Median length	31
Mean length	29.32948008
Min length	12

Characters and Unicode

Total characters	18415042
Distinct characters	56
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	TDF(300mg)+3TC(300mg)+DTG(50mg)
2nd row	TDF(300mg)+3TC(300mg)+EFV(600mg)
3rd row	TDF(300mg)+3TC(300mg)+DTG(50mg)
4th row	Cotrimoxazole 960mg
5th row	TDF(300mg)+3TC(300mg)+EFV(600mg)

Common Values

Value	Count	Frequency (%)
TDF(300mg)+3TC(300mg)+DTG(50mg)	206641	32.9%
TDF(300mg)+3TC(300mg)+EFV(600mg)	150496	24.0%
AZT(300mg)+3TC(150mg)+NVP(200mg)	101110	16.1%
Cotrimoxazole 960mg	93214	14.8%
Isoniazid 300mg	19095	3.0%
AZT(10mg/ml)+3TC(10mg/ml)+NVP(10mg/ml)	11386	1.8%
TDF(300mg)+3TC(150mg)+LPV/r(200/50mg)	6349	1.0%
Cotrimoxazole 480mg	4351	0.7%
TDF(300mg)+3TC(150mg)+ATV/r(300/100mg)	4296	0.7%
TDF(300mg)+3TC(30mg)+DTG(50mg)	3367	0.5%
Other values (78)	27563	4.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
tdf(300mg)+3tc(300mg)+dtg(50mg	206641	27.7%
tdf(300mg)+3tc(300mg)+efv(600mg	150496	20.2%
azt(300mg)+3tc(150mg)+nvp(200mg	101110	13.6%
cotrimoxazole	98366	13.2%
960mg	93214	12.5%
isoniazid	19479	2.6%
300mg	19095	2.6%
azt(10mg/ml)+3tc(10mg/ml)+nvp(10mg/ml	11386	1.5%
tdf(300mg)+3tc(150mg)+lpv/r(200/50mg	6349	0.9%
480mg	4351	0.6%
Other values (91)	35457	4.8%

Most occurring characters

Value	Count	Frequency (%)
0	2836166	15.4%
m	1775684	9.6%
g	1639258	8.9%
(	1520232	8.3%
)	1520232	8.3%
3	1401695	7.6%
T	1235348	6.7%
+	1010449	5.5%
C	613857	3.3%
D	592983	3.2%
Other values (46)	4269138	23.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5235615	28.4%
Lowercase Letter	4715096	25.6%
Uppercase Letter	4196819	22.8%
Open Punctuation	1520232	8.3%
Close Punctuation	1520232	8.3%
Math Symbol	1010449	5.5%
Space Separator	118076	0.6%
Other Punctuation	98523	0.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
m	1775684	37.7%
g	1639258	34.8%
o	315008	6.7%
i	137427	2.9%
l	136815	2.9%
r	119388	2.5%
a	118103	2.5%
z	118061	2.5%
e	98609	2.1%
t	98436	2.1%
Other values (12)	158307	3.4%

Uppercase Letter

Value	Count	Frequency (%)
T	1235348	29.4%
C	613857	14.6%
D	592983	14.1%
F	537658	12.8%
V	296700	7.1%
G	212685	5.1%
E	155724	3.7%
A	137570	3.3%
P	132729	3.2%
Z	123629	2.9%
Other values (8)	157936	3.8%

Decimal Number

Value	Count	Frequency (%)
0	2836166	54.2%
3	1401695	26.8%
5	347525	6.6%
6	253126	4.8%
1	167747	3.2%
2	123543	2.4%
9	93214	1.8%
4	7551	0.1%
8	4954	0.1%
7	94	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
/	98522	> 99.9%
,	1	< 0.1%

Open Punctuation

Value	Count	Frequency (%)
(	1520232	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1520232	100.0%

Math Symbol

Value	Count	Frequency (%)
+	1010449	100.0%

Space Separator

Value	Count	Frequency (%)
	118076	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	9503127	51.6%
Latin	8911915	48.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
m	1775684	19.9%
g	1639258	18.4%
T	1235348	13.9%
C	613857	6.9%
D	592983	6.7%
F	537658	6.0%
o	315008	3.5%
V	296700	3.3%
G	212685	2.4%
E	155724	1.7%
Other values (30)	1537010	17.2%

Common

Value	Count	Frequency (%)
0	2836166	29.8%
(	1520232	16.0%
)	1520232	16.0%
3	1401695	14.7%
+	1010449	10.6%
5	347525	3.7%
6	253126	2.7%
1	167747	1.8%
2	123543	1.3%
	118076	1.2%
Other values (6)	204336	2.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18415042	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2836166	15.4%
m	1775684	9.6%
g	1639258	8.9%
(	1520232	8.3%
)	1520232	8.3%
3	1401695	7.6%
T	1235348	6.7%
+	1010449	5.5%
C	613857	3.3%
D	592983	3.2%
Other values (46)	4269138	23.2%

PHARMACY_ID
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	627868
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1776095.166

Minimum	43649
Maximum	4082401
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.8 MiB

Quantile statistics

Minimum	43649
5-th percentile	258862.15
Q1	708182.75
median	1362669
Q3	3126253.25
95-th percentile	3824185.65
Maximum	4082401
Range	4038752
Interquartile range (IQR)	2418070.5

Descriptive statistics

Standard deviation	1255255.564
Coefficient of variation (CV)	0.7067501717
Kurtosis	-1.314320371
Mean	1776095.166
Median Absolute Deviation (MAD)	817529
Skewness	0.4738560264
Sum	1.11515332 × 10¹²
Variance	1.57566653 × 10¹²
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1054723	1	< 0.1%
2840650	1	< 0.1%
238369	1	< 0.1%
244514	1	< 0.1%
1291043	1	< 0.1%
232228	1	< 0.1%
2800320	1	< 0.1%
234279	1	< 0.1%
258859	1	< 0.1%
250671	1	< 0.1%
Other values (627858)	627858	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
43649	1	< 0.1%
43651	1	< 0.1%
43655	1	< 0.1%
43658	1	< 0.1%
43663	1	< 0.1%
43665	1	< 0.1%
43667	1	< 0.1%
43671	1	< 0.1%
43673	1	< 0.1%
43676	1	< 0.1%

Value	Count	Frequency (%)
4082401	1	< 0.1%
4082400	1	< 0.1%
4082399	1	< 0.1%
4082398	1	< 0.1%
4082397	1	< 0.1%
4082392	1	< 0.1%
4082391	1	< 0.1%
4082390	1	< 0.1%
4082386	1	< 0.1%
4082385	1	< 0.1%

PATIENT_ID
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	18825
Distinct (%)	3.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52581.71467

Minimum	19095
Maximum	160831
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.8 MiB

Quantile statistics

Minimum	19095
5-th percentile	20738
Q1	24167
median	29628
Q3	35078
95-th percentile	148392
Maximum	160831
Range	141736
Interquartile range (IQR)	10911

Descriptive statistics

Standard deviation	47159.52209
Coefficient of variation (CV)	0.8968806434
Kurtosis	-0.0603474067
Mean	52581.71467
Median Absolute Deviation (MAD)	5458
Skewness	1.341205344
Sum	3.301437603 × 10¹⁰
Variance	2224020523
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
148161	233	< 0.1%
113055	231	< 0.1%
89158	228	< 0.1%
112854	224	< 0.1%
116818	216	< 0.1%
147777	212	< 0.1%
112907	210	< 0.1%
89206	202	< 0.1%
116999	194	< 0.1%
112807	193	< 0.1%
Other values (18815)	625725	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
19095	4	< 0.1%
19098	1	< 0.1%
19101	44	< 0.1%
19104	78	< 0.1%
19107	8	< 0.1%
19110	85	< 0.1%
19111	79	< 0.1%
19117	4	< 0.1%
19120	50	< 0.1%
19123	107	< 0.1%

Value	Count	Frequency (%)
160831	4	< 0.1%
160808	4	< 0.1%
160807	4	< 0.1%
160806	4	< 0.1%
160805	4	< 0.1%
160804	4	< 0.1%
160802	10	< 0.1%
160801	106	< 0.1%
160800	5	< 0.1%
160799	5	< 0.1%

FACILITY_ID
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1888.15524

Minimum	1686
Maximum	2935
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.8 MiB

Quantile statistics

Minimum	1686
5-th percentile	1696
Q1	1752
median	1753
Q3	1753
95-th percentile	2929
Maximum	2935
Range	1249
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	390.4319905
Coefficient of variation (CV)	0.2067796028
Kurtosis	3.22749184
Mean	1888.15524
Median Absolute Deviation (MAD)	1
Skewness	2.272684395
Sum	1185512254
Variance	152437.1392
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
1753	193461	30.8%
1752	158799	25.3%
1696	118501	18.9%
2929	63739	10.2%
1831	30441	4.8%
1686	17916	2.9%
1755	15387	2.5%
2935	9632	1.5%
1817	9256	1.5%
1687	7251	1.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1686	17916	2.9%
1687	7251	1.2%
1696	118501	18.9%
1752	158799	25.3%
1753	193461	30.8%
1755	15387	2.5%
1817	9256	1.5%
1831	30441	4.8%
2929	63739	10.2%
2933	3485	0.6%

Value	Count	Frequency (%)
2935	9632	1.5%
2933	3485	0.6%
2929	63739	10.2%
1831	30441	4.8%
1817	9256	1.5%
1755	15387	2.5%
1753	193461	30.8%
1752	158799	25.3%
1696	118501	18.9%
1687	7251	1.2%

DATE_VISIT
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	4.8 MiB

DURATION
Real number (ℝ)

SKEWED

Distinct	145
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	77.84280295

Minimum	-30
Maximum	90212
Zeros	140
Zeros (%)	< 0.1%
Negative	1
Negative (%)	< 0.1%
Memory size	4.8 MiB

Quantile statistics

Minimum	-30
5-th percentile	30
Q1	60
median	60
Q3	90
95-th percentile	180
Maximum	90212
Range	90242
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	124.3629103
Coefficient of variation (CV)	1.597616036
Kurtosis	439469.154
Mean	77.84280295
Median Absolute Deviation (MAD)	30
Skewness	606.5115674
Sum	48875005
Variance	15466.13346
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60	271500	43.2%
30	123588	19.7%
90	102713	16.4%
180	76678	12.2%
120	26150	4.2%
15	7481	1.2%
14	3859	0.6%
56	3111	0.5%
168	2643	0.4%
84	1949	0.3%
Other values (135)	8196	1.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-30	1	< 0.1%
0	140	< 0.1%
1	4	< 0.1%
2	35	< 0.1%
3	18	< 0.1%
5	2	< 0.1%
6	26	< 0.1%
7	11	< 0.1%
8	5	< 0.1%
9	9	< 0.1%

Value	Count	Frequency (%)
90212	1	< 0.1%
1800	7	< 0.1%
1680	3	< 0.1%
1220	1	< 0.1%
1180	1	< 0.1%
1120	1	< 0.1%
1112	1	< 0.1%
960	7	< 0.1%
900	2	< 0.1%
601	3	< 0.1%

MORNING
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	42
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.767379212

Minimum	0
Maximum	2401
Zeros	225607
Zeros (%)	35.9%
Negative	0
Negative (%)	0.0%
Memory size	4.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	1
95-th percentile	1
Maximum	2401
Range	2401
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	9.062837272
Coefficient of variation (CV)	11.81011569
Kurtosis	25144.8799
Mean	0.767379212
Median Absolute Deviation (MAD)	0
Skewness	148.0439747
Sum	481812.8511
Variance	82.13501941
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=42)

Value	Count	Frequency (%)
1	381250	60.7%
0	225607	35.9%
3	13055	2.1%
2	7798	1.2%
10	39	< 0.1%
11	25	< 0.1%
1201	17	< 0.1%
601	9	< 0.1%
1.03	7	< 0.1%
31	5	< 0.1%
Other values (32)	56	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	225607	35.9%
0.03	3	< 0.1%
0.06	1	< 0.1%
1	381250	60.7%
1.0112	1	< 0.1%
1.015	1	< 0.1%
1.018	1	< 0.1%
1.03	7	< 0.1%
1.05	1	< 0.1%
1.056	1	< 0.1%

Value	Count	Frequency (%)
2401	1	< 0.1%
1960	1	< 0.1%
1801	1	< 0.1%
1511	1	< 0.1%
1201	17	< 0.1%
960	4	< 0.1%
901	4	< 0.1%
603	2	< 0.1%
601	9	< 0.1%
600	1	< 0.1%

AFTERNOON
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.8 MiB

0	627858
960	5
1	5

Length

Max length	3
Median length	1
Mean length	1.000015927
Min length	1

Characters and Unicode

Total characters	627878
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	627858	> 99.9%
960	5	< 0.1%
1	5	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	627858	> 99.9%
960	5	< 0.1%
1	5	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	627863	> 99.9%
1	5	< 0.1%
9	5	< 0.1%
6	5	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	627878	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	627863	> 99.9%
1	5	< 0.1%
9	5	< 0.1%
6	5	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	627878	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	627863	> 99.9%
1	5	< 0.1%
9	5	< 0.1%
6	5	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	627878	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	627863	> 99.9%
1	5	< 0.1%
9	5	< 0.1%
6	5	< 0.1%

EVENING
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.738782037

Minimum	0
Maximum	960
Zeros	199008
Zeros (%)	31.7%
Negative	0
Negative (%)	0.0%
Memory size	4.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	1
95-th percentile	1
Maximum	960
Range	960
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	2.788758845
Coefficient of variation (CV)	3.774805971
Kurtosis	111518.0424
Mean	0.738782037
Median Absolute Deviation (MAD)	0
Skewness	324.8214677
Sum	463857.6
Variance	7.777175895
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
1	412371	65.7%
0	199008	31.7%
3	13048	2.1%
2	3415	0.5%
960	5	< 0.1%
10	4	< 0.1%
1.5	3	< 0.1%
2.5	3	< 0.1%
100	2	< 0.1%
20	2	< 0.1%
Other values (7)	7	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	199008	31.7%
0.1	1	< 0.1%
1	412371	65.7%
1.5	3	< 0.1%
2	3415	0.5%
2.5	3	< 0.1%
3	13048	2.1%
3.5	1	< 0.1%
10	4	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
960	5	< 0.1%
180	1	< 0.1%
112	1	< 0.1%
100	2	< 0.1%
84	1	< 0.1%
30	1	< 0.1%
20	2	< 0.1%
11	1	< 0.1%
10	4	< 0.1%
3.5	1	< 0.1%

ADR_SCREENED
Boolean

MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	10322
Missing (%)	1.6%
Memory size	1.2 MiB

False	615707
True	1839
(Missing)	10322

Common Values
Chart

Value	Count	Frequency (%)
False	615707	98.1%
True	1839	0.3%
(Missing)	10322	1.6%

ADR_IDS
Categorical

HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	30.0%
Missing	627858
Missing (%)	> 99.9%
Memory size	4.8 MiB

10,1	4
4,6#1,1	3
8#1	3

Length

Max length	7
Median length	4
Mean length	4.6
Min length	3

Characters and Unicode

Total characters	46
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	10,1
2nd row	10,1
3rd row	4,6#1,1
4th row	10,1
5th row	10,1

Common Values

Value	Count	Frequency (%)
10,1	4	< 0.1%
4,6#1,1	3	< 0.1%
8#1	3	< 0.1%
(Missing)	627858	> 99.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
10,1	4	40.0%
8#1	3	30.0%
4,6#1,1	3	30.0%

Most occurring characters

Value	Count	Frequency (%)
1	17	37.0%
,	10	21.7%
#	6	13.0%
0	4	8.7%
4	3	6.5%
6	3	6.5%
8	3	6.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	30	65.2%
Other Punctuation	16	34.8%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	17	56.7%
0	4	13.3%
4	3	10.0%
6	3	10.0%
8	3	10.0%

Other Punctuation

Value	Count	Frequency (%)
,	10	62.5%
#	6	37.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	46	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	17	37.0%
,	10	21.7%
#	6	13.0%
0	4	8.7%
4	3	6.5%
6	3	6.5%
8	3	6.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	46	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	17	37.0%
,	10	21.7%
#	6	13.0%
0	4	8.7%
4	3	6.5%
6	3	6.5%
8	3	6.5%

PRESCRIP_ERROR
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.8 MiB

0	617725
1	10143

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	627868
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	617725	98.4%
1	10143	1.6%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	617725	98.4%
1	10143	1.6%

Most occurring characters

Value	Count	Frequency (%)
0	617725	98.4%
1	10143	1.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	627868	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	617725	98.4%
1	10143	1.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	627868	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	617725	98.4%
1	10143	1.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	627868	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	617725	98.4%
1	10143	1.6%

ADHERENCE
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.8 MiB

1	346979
0	280889

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	627868
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	0
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	346979	55.3%
0	280889	44.7%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	346979	55.3%
0	280889	44.7%

Most occurring characters

Value	Count	Frequency (%)
1	346979	55.3%
0	280889	44.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	627868	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	346979	55.3%
0	280889	44.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	627868	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	346979	55.3%
0	280889	44.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	627868	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	346979	55.3%
0	280889	44.7%

NEXT_APPOINTMENT
Unsupported

REJECTED
UNSUPPORTED

Missing	6
Missing (%)	< 0.1%
Memory size	4.8 MiB

DMOC_TYPE
Categorical

HIGH CORRELATION
MISSING

Distinct	11
Distinct (%)	< 0.1%
Missing	460552
Missing (%)	73.4%
Memory size	4.8 MiB

MMD	76108
Same Facility Refill	53701
Individual delivery/home-based	21053
MMS	14898
CPARP	925
Other values (6)	631

Length

Max length	51
Median length	3
Mean length	11.95987831
Min length	3

Characters and Unicode

Total characters	2001079
Distinct characters	37
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MMD
2nd row	MMD
3rd row	MMD
4th row	MMS
5th row	Same Facility Refill

Common Values

Value	Count	Frequency (%)
MMD	76108	12.1%
Same Facility Refill	53701	8.6%
Individual delivery/home-based	21053	3.4%
MMS	14898	2.4%
CPARP	925	0.1%
Different Facility Refill (Private hospital/clinic)	269	< 0.1%
CARC	199	< 0.1%
Group delivery/CARC	99	< 0.1%
Mobile van/other vehicle	40	< 0.1%
Fixed or ad hoc pick up points	14	< 0.1%
(Missing)	460552	73.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
mmd	76108	25.6%
facility	53970	18.2%
refill	53970	18.2%
same	53701	18.1%
individual	21053	7.1%
delivery/home-based	21053	7.1%
mms	14898	5.0%
cparp	925	0.3%
hospital/clinic	269	0.1%
private	269	0.1%
Other values (15)	894	0.3%

Most occurring characters

Value	Count	Frequency (%)
i	226635	11.3%
l	204733	10.2%
e	193072	9.6%
M	182052	9.1%
a	150369	7.5%
	129794	6.5%
d	84339	4.2%
D	76377	3.8%
y	75122	3.8%
m	74754	3.7%
Other values (27)	603832	30.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1366003	68.3%
Uppercase Letter	462230	23.1%
Space Separator	129794	6.5%
Other Punctuation	21461	1.1%
Dash Punctuation	21053	1.1%
Open Punctuation	269	< 0.1%
Close Punctuation	269	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	226635	16.6%
l	204733	15.0%
e	193072	14.1%
a	150369	11.0%
d	84339	6.2%
y	75122	5.5%
m	74754	5.5%
t	54841	4.0%
c	54576	4.0%
f	54508	4.0%
Other values (11)	193054	14.1%

Uppercase Letter

Value	Count	Frequency (%)
M	182052	39.4%
D	76377	16.5%
S	68599	14.8%
R	55193	11.9%
F	53984	11.7%
I	21053	4.6%
P	2119	0.5%
C	1521	0.3%
A	1223	0.3%
G	99	< 0.1%

Space Separator

Value	Count	Frequency (%)
	129794	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	21461	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	21053	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	269	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	269	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1828233	91.4%
Common	172846	8.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	226635	12.4%
l	204733	11.2%
e	193072	10.6%
M	182052	10.0%
a	150369	8.2%
d	84339	4.6%
D	76377	4.2%
y	75122	4.1%
m	74754	4.1%
S	68599	3.8%
Other values (22)	492181	26.9%

Common

Value	Count	Frequency (%)
	129794	75.1%
/	21461	12.4%
-	21053	12.2%
(	269	0.2%
)	269	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2001079	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	226635	11.3%
l	204733	10.2%
e	193072	9.6%
M	182052	9.1%
a	150369	7.5%
	129794	6.5%
d	84339	4.2%
D	76377	3.8%
y	75122	3.8%
m	74754	3.7%
Other values (27)	603832	30.2%

BODY_WEIGHT
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	75
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.138822348

Minimum	0
Maximum	856
Zeros	625049
Zeros (%)	99.6%
Negative	0
Negative (%)	0.0%
Memory size	4.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	856
Range	856
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3.469496776
Coefficient of variation (CV)	24.99235048
Kurtosis	31028.80829
Mean	0.138822348
Median Absolute Deviation (MAD)	0
Skewness	138.7964098
Sum	87162.11
Variance	12.03740788
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	625049	99.6%
30	254	< 0.1%
20	244	< 0.1%
25	216	< 0.1%
68	137	< 0.1%
17	109	< 0.1%
56	104	< 0.1%
10	101	< 0.1%
21	99	< 0.1%
15	99	< 0.1%
Other values (65)	1456	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	625049	99.6%
0.25	3	< 0.1%
1.1	3	< 0.1%
1.3	4	< 0.1%
5	15	< 0.1%
6	9	< 0.1%
7	12	< 0.1%
8	14	< 0.1%
8.5	3	< 0.1%
9	49	< 0.1%

Value	Count	Frequency (%)
856	4	< 0.1%
687	3	< 0.1%
78	39	< 0.1%
72	3	< 0.1%
71	6	< 0.1%
69	11	< 0.1%
68	137	< 0.1%
65	45	< 0.1%
64	53	< 0.1%
63	3	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	State	L.G.A	Facility Name	Regimen Line	Regimen	PHARMACY_ID	PATIENT_ID	FACILITY_ID	DATE_VISIT	DURATION	MORNING	EVENING	ADR_SCREENED	ADR_IDS	ADHERENCE	NEXT_APPOINTMENT	DMOC_TYPE
0	Cross River	Obudu	Obudu Clinic	ART First Line Adult	TDF(300mg)+3TC(300mg)+DTG(50mg)	43649	19757	1686	2019-06-05 00:00:00	60	1.0	0.0	No	NaN	1	2019-08-05 00:00:00	NaN
1	Cross River	Obudu	Obudu Clinic	ART First Line Adult	TDF(300mg)+3TC(300mg)+EFV(600mg)	43651	19228	1686	2017-07-18 00:00:00	60	1.0	1.0	No	NaN	1	2017-09-16 00:00:00	NaN
2	Cross River	Obudu	Obudu Clinic	ART First Line Adult	TDF(300mg)+3TC(300mg)+DTG(50mg)	43655	19182	1686	2020-04-24 00:00:00	180	0.0	1.0	No	NaN	0	2020-10-24 00:00:00	MMD
3	Cross River	Obudu	Obudu Clinic	Cotrimoxazole (CTX) Prophylaxis	Cotrimoxazole 960mg	43658	19123	1686	2016-10-19 00:00:00	60	1.0	0.0	No	NaN	1	2016-12-19 00:00:00	NaN
4	Cross River	Obudu	Obudu Clinic	ART First Line Adult	TDF(300mg)+3TC(300mg)+EFV(600mg)	43663	19764	1686	2017-05-23 00:00:00	30	1.0	1.0	No	NaN	1	2017-06-21 00:00:00	NaN
5	Cross River	Obudu	Obudu Clinic	ART First Line Children	AZT/3TC/NVP(60/30/50mg)	43665	19487	1686	2017-06-23 00:00:00	120	1.0	1.0	No	NaN	1	2017-08-23 00:00:00	NaN
6	Cross River	Obudu	Obudu Clinic	ART First Line Adult	TDF(300mg)+3TC(300mg)+EFV(600mg)	43667	19832	1686	2019-02-21 00:00:00	60	1.0	1.0	No	NaN	1	2019-04-21 00:00:00	NaN
7	Cross River	Obudu	Obudu Clinic	ART First Line Adult	TDF(300mg)+3TC(300mg)+DTG(50mg)	43671	19759	1686	2019-06-15 00:00:00	60	0.0	1.0	No	NaN	1	2019-08-15 00:00:00	NaN
8	Cross River	Obudu	Obudu Clinic	ART First Line Adult	AZT(300mg)+3TC(150mg)+NVP(200mg)	43673	19475	1686	2016-11-21 00:00:00	60	1.0	1.0	No	NaN	1	2017-01-19 00:00:00	NaN
9	Cross River	Obudu	Obudu Clinic	Cotrimoxazole (CTX) Prophylaxis	Cotrimoxazole 960mg	43676	19934	1686	2020-02-11 00:00:00	90	1.0	0.0	No	NaN	0	2020-05-11 00:00:00	MMD

Last rows

	State	L.G.A	Facility Name	Regimen Line	Regimen	PHARMACY_ID	PATIENT_ID	FACILITY_ID	DATE_VISIT	DURATION	MORNING	EVENING	ADR_SCREENED	ADR_IDS	NEXT_APPOINTMENT	DMOC_TYPE
627858	Cross River	Ogoja	Ogoja Catholic Maternity Hospital	ART First Line Adult	TDF(300mg)+3TC(300mg)+DTG(50mg)	4082385	24597	1752	2021-05-26 00:00:00	180	1.0	0.0	No	NaN	2021-11-29 00:00:00	Same Facility Refill
627859	Cross River	Ogoja	Ogoja Catholic Maternity Hospital	ART First Line Adult	TDF(300mg)+3TC(300mg)+DTG(50mg)	4082386	113174	1752	2021-05-25 00:00:00	180	0.0	1.0	No	NaN	2021-11-23 00:00:00	Same Facility Refill
627860	Cross River	Ogoja	Ogoja Catholic Maternity Hospital	ART First Line Adult	TDF(300mg)+3TC(300mg)+DTG(50mg)	4082390	154849	1752	2021-05-25 00:00:00	90	0.0	1.0	No	NaN	2021-08-27 00:00:00	Same Facility Refill
627861	Cross River	Ogoja	Ogoja Catholic Maternity Hospital	ART First Line Adult	TDF(300mg)+3TC(300mg)+DTG(50mg)	4082391	23910	1752	2021-05-25 00:00:00	180	0.0	1.0	No	NaN	2021-11-16 00:00:00	Same Facility Refill
627862	Cross River	Ogoja	Ogoja Catholic Maternity Hospital	ART First Line Adult	TDF(300mg)+3TC(300mg)+DTG(50mg)	4082392	26495	1752	2021-05-26 00:00:00	180	0.0	1.0	No	NaN	2021-11-29 00:00:00	Same Facility Refill
627863	Cross River	Ogoja	Ogoja Catholic Maternity Hospital	ART First Line Adult	TDF(300mg)+3TC(300mg)+DTG(50mg)	4082397	27515	1752	2021-05-25 00:00:00	180	1.0	0.0	No	NaN	2021-11-29 00:00:00	Same Facility Refill
627864	Cross River	Ogoja	Ogoja Catholic Maternity Hospital	ART First Line Adult	TDF(300mg)+3TC(300mg)+DTG(50mg)	4082398	24628	1752	2021-05-27 00:00:00	90	1.0	0.0	No	NaN	2021-08-30 00:00:00	Same Facility Refill
627865	Cross River	Ogoja	Ogoja Catholic Maternity Hospital	ART First Line Adult	TDF(300mg)+3TC(300mg)+DTG(50mg)	4082399	27517	1752	2021-05-25 00:00:00	90	0.0	1.0	No	NaN	2021-08-30 00:00:00	Same Facility Refill
627866	Cross River	Ogoja	Ogoja Catholic Maternity Hospital	ART First Line Adult	TDF(300mg)+3TC(300mg)+DTG(50mg)	4082400	25502	1752	2021-05-26 00:00:00	180	1.0	0.0	No	NaN	2021-11-29 00:00:00	Same Facility Refill
627867	Cross River	Ogoja	Ogoja Catholic Maternity Hospital	ART First Line Adult	TDF(300mg)+3TC(300mg)+DTG(50mg)	4082401	23377	1752	2021-05-26 00:00:00	90	0.0	1.0	No	NaN	2021-08-30 00:00:00	Same Facility Refill

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Open Punctuation

Close Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Open Punctuation

Close Punctuation

Math Symbol

Space Separator

Most occurring scripts